Maintenance Dashboard
Weekly job performance · builds its own history as you add weeks
Reporting period
6/15 - 6/19 – 7/13 - 7/17
Week
History & trends
Week over week across every file added
Pick a weekly maintenance Excel file. It's read in your browser and added to the shared history.
Preview mode — open the shared dashboard to save history
151 job lines · $80,547 revenue · $28,439 est. profit
Earned revenue
$408,149
765 job lines
Gross profit
$248,480
60.9% margin · before overhead
Estimated profit
$166,850
after 20% OH · 40.9% margin
Hours: actual vs est
91%
599h under budget
Crew hours vs. estimate
Actual hours against the estimated budget (dashed).
6/15 - 6/19
1,150h / 1,042h · 110%
6/22 - 6/26
1,063h / 1,361h · 78%
6/29 - 7/2
1,393h / 1,847h · 75%
7/6 - 7/10
1,302h / 1,303h · 100%
7/13 - 7/17
1,417h / 1,369h · 103%
Under budget
Over budget
Estimated
Revenue by service
Where the money comes from
Top properties
By earned revenue · all weeks
Needs attention
Client jobs with negative gross profit, the biggest time overruns, and clients whose margin is slipping week over week.
| Property | Service | Est hrs | Act hrs | Over by |
|---|---|---|---|---|
| Lake Carl Blackwell Dam | Mow, Edge, Weed Eat | 128.0 | 166.5 | +38.5h |
| Moore Task 32 | Mow, Edge, Weed Eat | 14.3 | 41.4 | +27.1h |
| Moore Task 42 | Mow, Edge, Weed Eat | 12.4 | 36.9 | +24.6h |
| OKC 131 | Mow, Edge, Weed Eat | 57.4 | 78.3 | +20.9h |
| OKC 131 | Mow, Edge, Weed Eat | 57.4 | 78.3 | +20.9h |
| Moore Task 43 | Mow, Edge, Weed Eat | 11.9 | 31.0 | +19.1h |
| OKC 131 | Mow, Edge, Weed Eat | 57.4 | 74.7 | +17.3h |
| CON-Deer Creek Intermediate School | Mow, Edge, Weed Eat | 9.0 | 25.7 | +16.7h |
| Moore Task 6 | Mow, Edge, Weed Eat | 6.2 | 20.8 | +14.6h |
| YMCA | Irrig Repair | 2.0 | 16.6 | +14.6h |
| Moore Task 1 | Mow, Edge, Weed Eat | 12.2 | 26.7 | +14.5h |
| Moore Task 42 | Mow, Edge, Weed Eat | 12.4 | 25.8 | +13.5h |